import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;


public class TodoDatabaseHelper extends SQLiteOpenHelper {
		private static final String DATABASE_NAME = "applicationdata";

		private static final int DATABASE_VERSION = 1;

		// Database creation sql statement
		private static final String DATABASE_CREATE = "create table todo (_id integer primary key autoincrement, "
				+ "category text not null, summary text not null, description text not null);";

		public TodoDatabaseHelper(Context context) {
			super(context, DATABASE_NAME, null, DATABASE_VERSION);
		}

		// Method is called during creation of the database
		@Override
		public void onCreate(SQLiteDatabase database) {
			database.execSQL(DATABASE_CREATE);
		}

		// Method is called during an upgrade of the database, e.g. if you increase
		// the database version
		@Override
		public void onUpgrade(SQLiteDatabase database, int oldVersion,
				int newVersion) {
			Log.w(TodoDatabaseHelper.class.getName(),
					"Upgrading database from version " + oldVersion + " to "
							+ newVersion + ", which will destroy all old data");
			database.execSQL("DROP TABLE IF EXISTS todo");
			onCreate(database);
		}
	}